-
Enhance the VLOOKUP function to take a date, using it to lookup the value in the cell history
Sorry if this is a duplicate. I can see the Idea that I created earlier today in my notifications. It states that the status has changed. But when I click on it (https://community.smartsheet.com/disc…2 · -
Formula to lookup prior cell values
...and not require use of the API*. Often, people want to create Smartsheets that use or track values of cells in a(nother) sheet over time, or look up a prior value using a date, or a date formula. …1 · -
Call APIs from a formula
Alternate title: Make the most requested calls to an (ideally every) API available as formulas. Often in the community, someone will ask how to do something in a formula. Often, the response is, &quo…3 · -
Re: Report Summary and Grouping: add custom formatting
YES AND - be able to group and summarize by count AND percent of total. Imagine if...in the attached, mocked up an existing count by group report to include percent of total. Of course, we'd need to …4 ·